IF  EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'TblDefineMessage'
          AND COLUMN_NAME = 'message'
)
    ALTER TABLE dbo.TblDefineMessage alter column  message nVARCHAR(MAX) NULL;


   